﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$ArticleDBConnection$" >
	<Sql>
		INSERT INTO eComProducts
		(id,companyId,partId,supplierPartId,supplierId,avgCostPrice,listPrice,sellPrice,weight,weightUnit,width,widthUnit,length,lengthUnit,depth,depthUnit,pricingId)
		VALUES
		(@id,@companyId,@partId,@supplierPartId,@supplierId,@avgCostPrice,@listPrice,@sellPrice,@weight,@weightUnit,@width,@widthUnit,@length,@lengthUnit,@depth,@depthUnit,@pricingId)
	</Sql>

	<Param name="id" type="UniqueIdentifier"/>
	<Param name="companyId" type="UniqueIdentifier"/>
	<Param name="supplier.id" dbName="supplierId" type="UniqueIdentifier"/>
	<Param name="partId" type="UnicodeVarChar"/>
	<Param name="supplierPartId" type="UnicodeVarChar"/>
	<Param name="avgCostPrice" type="Money" />
	<Param name="listPrice" type="Money" />
	<Param name="sellPrice" type="Money" />
	<Param name="weight.amount" dbName="weight"  type="Decimal" />
	<Param name="weight.unit" dbName="weightUnit"  type="UnicodeVarChar"/>
	<Param name="dimensions.width.amount" dbName="width" type="Decimal" />
	<Param name="dimensions.width.unit" dbName="widthUnit"  type="UnicodeVarChar"/>
	<Param name="dimensions.length.amount" dbName="length" type="Decimal" />
	<Param name="dimensions.length.unit" dbName="lengthUnit"  type="UnicodeVarChar"/>
	<Param name="dimensions.depth.amount" dbName="depth" type="Decimal" />
	<Param name="dimensions.depth.unit" dbName="depthUnit"  type="UnicodeVarChar"/>
	<Param name="pricingId" type="Char" />
</AdoNetDataAccess>